Data Prep 2: They Changed Accounting Systems

Price: $ 14.99



Students use Excel or another Extract Transform Load (ETL) tool to first clean and scrub data. In this scenario, the company changed accounting systems at the end of January. As a result, the January journal sheet is in a different format than the February to December journal sheet. The two sheets need to be reconciled and merged. They then export an Unadjusted Trial Balance to Excel. Next, students must answer a set of analytic questions from their Excel file. The numbers are unique to each student. As a result, the correct answers to the analytic questions will be different and unique for every student. The case can be solved using Alteryx, Power BI or Tableau and a free mini tutorial and data set is available.

Table of contents

View chapter in pdf form

View chapter in ppt form

The book comes with a quizzing system, with each student being presented with a timed quiz comprising five questions selected at random from the database of quiz questions for the chapter. Instructors can assign these quizzes in advance of the topics to be covered in class, giving students an incentive to read the chapter in advance of the class. Students read the chapters and take the online quizzes prior to class.

Each chapter features hyperlinks to related information, taking advantage of the online nature of the book. Additionally, the chapters featuring Microsoft Access databases permit the databases to be downloaded by students for further exploration.

The following are some of the resources available for adopting instructors:

  • Solutions to end-of-chapter questions and problems
  • The ability to make selected solutions available to students
  • The ability to view all quiz questions for a chapter
  • The ability to generate quiz grade reports
  • Sample tests
  • Powerpoint files for each chapter

Videos Demo

Other products


E-Books

No Image Available.
No Image Available.
No Image Available.

Analytics Products

No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.

Excel Accounting Practice Sets

No Image Available.
No Image Available.
No Image Available.
No Image Available.